{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":150,"n_cols":14,"rows_kept":150,"merged":[[0,9,9,13],[12,1,12,12],[47,1,47,2],[141,1,141,2],[142,1,142,2]]}
[{"$nulls":9},"Приложение № 1 к постановлению руководителя Исполнительного комитета Сармановского муниципального района _________________________________ от ___________2018г. № _______"]
{"$rows_empty":11}
[null,"Расчет цены на оказание платной услуги по учреждениям образования Сармановского муниципального района РТ"]
[]
[]
[null,"Муниципальные бюджетные дошкольные образовательные учреждения"]
[]
[null,"Вид расходов","Дж ДОУ №1","Дж ДОУ № 3","Дж ДОУ № 4","Дж ДОУ № 5","Дж ДОУ № 6","Дж ДОУ № 7","Сарм ДОУ № 1","Сарм ДОУ № 2","Сарм ДОУ № 3","Сарм ДОУ № 4","П-Завод ДОУ ","Сельские ДОУ"]
[]
[null,"Общая площадь здания",1460.3,1717.3,1670.1,1983.9,3598,2001.4,1085.1,1151.1,1670.9,2585.8,1053.9,1053.9]
[null,"Площадь для занятий",60,60,60,60,60,60,60,60,60,60,60,60]
[null,"Количество занятий в месяц",4,4,4,4,4,4,4,4,4,4,4,4]
[null,"Количество детей в группе",15,15,15,15,15,15,15,15,15,15,15,15]
[null,"Стоимость используемого оборудованя, мат. Запасов",34825,34825,34825,34825,34825,34825,34825,34825,34825,34825,34825,34825]
[null,"Количество потребленной электроэнергии в год",47560,56680,40740,37020,63120,32250,52098,49160,45407,90970,17483,17483]
[]
[null,"Оплата труда на 1 обучающего"]
[null,"Оклад",14232,14232,14232,14232,14232,14232,14232,14232,14232,14232,14232,14232]
[null,"1 категориия к окладу ",3842.64,3842.64,3842.64,3842.64,3842.64,3842.64,3842.64,3842.64,3842.64,3842.64,3842.64,3842.64]
[null,"Итого",{"$f":"C28+C29","v":18074.64},{"$f":"D28+D29","v":18074.64},18074.64,18074.64,18074.64,18074.64,18074.64,18074.64,18074.64,18074.64,18074.64,18074.64]
[null,"Начисление на заработную плату",{"$f":"C30*30.2%","v":{"v":5458.5412799999995,"d":"5458.54"}},{"$f":"D30*30.2%","v":{"v":5458.5412799999995,"d":"5458.54"}},{"$f":"E30*30.2%","v":{"v":5458.5412799999995,"d":"5458.54"}},{"v":5458.5412799999995,"d":"5458.54"},{"v":5458.5412799999995,"d":"5458.54"},{"v":5458.5412799999995,"d":"5458.54"},{"v":5458.5412799999995,"d":"5458.54"},{"v":5458.5412799999995,"d":"5458.54"},{"v":5458.5412799999995,"d":"5458.54"},{"v":5458.5412799999995,"d":"5458.54"},{"v":5458.5412799999995,"d":"5458.54"},{"v":5458.5412799999995,"d":"5458.54"}]
[null,"Всего",{"$f":"C30+C31","v":23533.181279999997},{"$f":"D30+D31","v":23533.181279999997},23533.181279999997,23533.181279999997,23533.181279999997,23533.181279999997,23533.181279999997,23533.181279999997,23533.181279999997,23533.181279999997,23533.181279999997,23533.181279999997]
[null,"Нагрузка пед персонала",18,18,18,18,18,18,18,18,18,18,18,18]
[null,"Количество недель в месяце",4,4,4,4,4,4,4,4,4,4,4,4]
[null,"Количество детей в группе",15,15,15,15,15,15,15,15,15,15,15,15]
[null,"Всего оплата труда ",{"$f":"C32/C33/C34/C35","v":{"v":21.789982666666663,"d":"21.79"}},{"$f":"D32/D33/D34/D35","v":{"v":21.789982666666663,"d":"21.79"}},{"v":21.789982666666663,"d":"21.79"},{"v":21.789982666666663,"d":"21.79"},{"v":21.789982666666663,"d":"21.79"},{"v":21.789982666666663,"d":"21.79"},{"v":21.789982666666663,"d":"21.79"},{"v":21.789982666666663,"d":"21.79"},{"v":21.789982666666663,"d":"21.79"},{"v":21.789982666666663,"d":"21.79"},{"v":21.789982666666663,"d":"21.79"},{"v":21.789982666666663,"d":"21.79"}]
[]
[]
[]
[]
[null,"Затраты на материальные запасы на 1 ребенка"]
[null,"Материальные запасы",34825,34825,34825,34825,34825,34825,34825,34825,34825,34825,34825,34825]
[null,"Количество месяцев",36,36,36,36,36,36,36,36,36,36,36,36]
[null,"Количество недель в месяце",4,4,4,4,4,4,4,4,4,4,4,4]
[null,"Количество детей в группе",15,15,15,15,15,15,15,15,15,15,15,15]
[null,"Всег по материальным запасам",{"$f":"C42/C43/C44/C45","v":{"v":16.122685185185183,"d":"16.12"}},{"$f":"D42/D43/D44/D45","v":{"v":16.122685185185183,"d":"16.12"}},{"v":16.122685185185183,"d":"16.12"},{"v":16.122685185185183,"d":"16.12"},{"v":16.122685185185183,"d":"16.12"},{"v":16.122685185185183,"d":"16.12"},{"v":16.122685185185183,"d":"16.12"},{"v":16.122685185185183,"d":"16.12"},{"v":16.122685185185183,"d":"16.12"},{"v":16.122685185185183,"d":"16.12"},{"v":16.122685185185183,"d":"16.12"},{"v":16.122685185185183,"d":"16.12"}]
[]
[null,"Расчет накладных затрат"]
[null,"Прогноз затрат АУП"]
[null,"Прогноз затрат общехозяйственного назначения",{"$f":"C115+C123+C140","v":{"v":12.601344281226767,"d":"12.60"}},{"$f":"D115+D123+D140","v":{"v":12.566715908273846,"d":"12.57"}},{"v":12.49684466980547,"d":"12.50"},{"v":12.41064423385358,"d":"12.41"},{"v":12.315862147255245,"d":"12.32"},{"v":12.386500227954233,"d":"12.39"},{"v":12.396128362965738,"d":"12.40"},{"v":12.361875231107055,"d":"12.36"},{"v":12.15453273621078,"d":"12.15"},{"v":12.16662766594283,"d":"12.17"},{"v":12.101774432849435,"d":"12.10"},{"v":12.039167833551588,"d":"12.04"}]
[null,"Прогноз суммы начисленной амортизации имущества общехоз. назначения",15.96,15.96,15.96,15.96,15.96,15.96,15.96,15.96,15.96,15.96,15.96,15.96]
[null,"Прогноз ФОТ основного персонала",21.79,21.79,21.79,21.79,21.79,21.79,21.79,21.79,21.79,21.79,21.79,21.79]
[null,"Коэффициент накладных затрат ",0.61,0.61,0.61,0.61,0.61,0.61,0.61,0.61,0.61,0.61,0.61,0.61]
[null,"Затраты на основной персонал",16.56,16.56,16.56,16.56,16.56,16.56,16.56,16.56,16.56,16.56,16.56,16.56]
[null,"Итого накладные затраты (в час на 1 ребенка)",{"v":12.6,"d":"12.60"},12.57,{"v":12.5,"d":"12.50"},12.41,12.32,12.39,12.4,12.36,12.15,12.17,12.1,12.04]
[]
[null,"Затраты на коммунальные услуги (2017год)"]
[null,"Электроэнергия за год кВТ/час",47560,56680,40740,37020,63120,32250,52098,49160,45407,90970,17483,17483]
[null,"Количество дней в году",248,248,248,248,248,248,248,248,248,296,248,248]
[null,"Часы",12,12,12,12,12,12,12,12,12,12,12,12]
[null,"Площадь здания",1460.3,1717.3,1670.1,1983.9,3598,2001.4,1085.1,1151.1,1670.9,2585.8,1053.9,1053.9]
[null,"Площадь для занятий",60,60,60,60,60,60,60,60,60,60,60,60]
[null,"Всего кВТ на 1 занятие",{"$f":"C58/C59/C60/C61*C62","v":{"v":0.6566260136560539,"d":"0.657"}},{"$f":"D58/D59/D60/D61*D62","v":{"v":0.6654294156430857,"d":"0.665"}},{"v":0.4918094531716278,"d":"0.492"},{"v":0.3762140066242933,"d":"0.376"},{"v":0.3536911187218706,"d":"0.354"},{"v":0.3248733950750603,"d":"0.325"},{"v":0.9679871930935456,"d":"0.968"},{"v":0.8610277406463944,"d":"0.861"},{"v":0.5478865938580522,"d":"0.548"},{"v":0.59426692141906,"d":"0.594"},{"v":0.33445283111270274,"d":"0.334"},{"v":0.33445283111270274,"d":"0.334"}]
[null,"Тариф",6.5705,6.5705,6.5705,6.5705,6.5705,6.5705,6.5705,6.5705,6.5705,6.5705,6.5705,6.5705]
[null,"Электроэнергия Итого",{"$f":"C63*C64","v":{"v":4.314361222727102,"d":"4.31"}},{"$f":"D63*D64","v":{"v":4.372203975482894,"d":"4.37"}},{"v":3.2314340120641805,"d":"3.23"},{"v":2.471914130524919,"d":"2.47"},{"v":2.323927495562051,"d":"2.32"},{"v":2.134580642340684,"d":"2.13"},{"v":6.360159852221142,"d":"6.36"},{"v":5.657382769917135,"d":"5.66"},{"v":3.5998888649443317,"d":"3.60"},{"v":3.904630807183934,"d":"3.90"},{"v":2.1975223268260136,"d":"2.20"},{"v":2.1975223268260136,"d":"2.20"}]
[null,"Вода"]
[null,"Норматив в день на 1 ребенка, л",75,75,75,75,75,75,75,75,75,75,75,75]
[null,"Часы работы",12,12,12,12,12,12,12,12,12,12,12,12]
[null,"Показатель",1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[null,"Итого м. куб.",{"$f":"C67/C68/C69","v":0.00625},{"$f":"D67/D68/D69","v":0.00625},0.00625,0.00625,0.00625,0.00625,0.00625,0.00625,0.00625,0.00625,0.00625,0.00625]
[null,"Тариф",{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},26.88,26.88,26.88,26.88,26.72,26.72]
[null,"Количество детей",15,15,15,15,15,15,15,15,15,15,15,15]
[null,"Всего на 1 занятие",{"$f":"C70*C71*C72","v":{"v":4.696875,"d":"4.70"}},{"v":4.696875,"d":"4.70"},{"v":4.696875,"d":"4.70"},{"v":4.696875,"d":"4.70"},{"v":4.696875,"d":"4.70"},{"v":4.696875,"d":"4.70"},2.52,2.52,2.52,2.52,{"v":2.5050000000000003,"d":"2.51"},{"v":2.5050000000000003,"d":"2.51"}]
[null,"Норматив на двух работников ( воспитатель, уборщица), л",40,40,40,40,40,40,40,40,40,40,40,40]
[null,"Часы работы",12,12,12,12,12,12,12,12,12,12,12,12]
[null,"Показатель",1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[null,"Итого м. куб.",{"$f":"C74/C75/C76","v":{"v":3.3333333333333335E-3,"d":"0.003"}},{"$f":"D74/D75/D76","v":{"v":3.3333333333333335E-3,"d":"0.003"}},{"v":3.3333333333333335E-3,"d":"0.003"},{"v":3.3333333333333335E-3,"d":"0.003"},{"v":3.3333333333333335E-3,"d":"0.003"},{"v":3.3333333333333335E-3,"d":"0.003"},{"v":3.3333333333333335E-3,"d":"0.003"},{"v":3.3333333333333335E-3,"d":"0.003"},{"v":3.3333333333333335E-3,"d":"0.003"},{"v":3.3333333333333335E-3,"d":"0.003"},{"v":3.3333333333333335E-3,"d":"0.003"},{"v":3.3333333333333335E-3,"d":"0.003"}]
[null,"Тариф",{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},26.88,26.88,26.88,26.88,26.72,26.72]
[null,"Всего по персоналу",{"$f":"C77*C78","v":{"v":0.167,"d":"0.17"}},{"$f":"D77*D78","v":{"v":0.167,"d":"0.17"}},{"v":0.167,"d":"0.17"},{"v":0.167,"d":"0.17"},{"v":0.167,"d":"0.17"},{"v":0.167,"d":"0.17"},{"v":0.0896,"d":"0.09"},{"v":0.0896,"d":"0.09"},{"v":0.0896,"d":"0.09"},{"v":0.0896,"d":"0.09"},{"v":0.08906666666666667,"d":"0.09"},{"v":0.08906666666666667,"d":"0.09"}]
[null,"На мытье полов, л",75,75,75,75,75,75,75,75,75,75,75,75]
[null,"Показатель",1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[null,"Итого м. куб.",{"$f":"C80/C81","v":0.075},{"$f":"D80/D81","v":0.075},0.075,0.075,0.075,0.075,0.075,0.075,0.075,0.075,0.075,0.075]
[null,"Тариф",{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},{"v":50.1,"d":"50.10"},26.88,26.88,26.88,26.88,26.72,26.72]
[null,"Всего на мытье полов",{"$f":"C82*C83","v":{"v":3.7575,"d":"3.76"}},{"$f":"D82*D83","v":{"v":3.7575,"d":"3.76"}},{"v":3.7575,"d":"3.76"},{"v":3.7575,"d":"3.76"},{"v":3.7575,"d":"3.76"},{"v":3.7575,"d":"3.76"},{"v":2.016,"d":"2.02"},{"v":2.016,"d":"2.02"},{"v":2.016,"d":"2.02"},{"v":2.016,"d":"2.02"},{"v":2.004,"d":"2.00"},{"v":2.004,"d":"2.00"}]
[null,"Водоотведение, куб.м. ",0.085,0.085,0.085,0.085,0.085,0.085,0.085,0.085,0.085,0.085,0.085,0.085]
[null,"Тариф",28.39,28.39,28.39,28.39,28.39,28.39,{"v":35.1,"d":"35.10"},{"v":35.1,"d":"35.10"},{"v":35.1,"d":"35.10"},{"v":35.1,"d":"35.10"},{"v":35.1,"d":"35.10"},{"v":35.1,"d":"35.10"}]
[null,"Всего по водоотведению",{"$f":"C85*C86","v":{"v":2.4131500000000004,"d":"2.41"}},{"$f":"D85*D86","v":{"v":2.4131500000000004,"d":"2.41"}},{"v":2.4131500000000004,"d":"2.41"},{"v":2.4131500000000004,"d":"2.41"},{"v":2.4131500000000004,"d":"2.41"},{"v":2.4131500000000004,"d":"2.41"},{"v":2.9835000000000003,"d":"2.98"},{"v":2.9835000000000003,"d":"2.98"},{"v":2.9835000000000003,"d":"2.98"},{"v":2.9835000000000003,"d":"2.98"},{"v":2.9835000000000003,"d":"2.98"},{"v":2.9835000000000003,"d":"2.98"}]
[null,"Всего расходов по водоснабжению и водоотведению",{"$f":"C73+C79+C84+C87","v":{"v":11.034525,"d":"11.03"}},{"$f":"D73+D79+D84+D87","v":{"v":11.034525,"d":"11.03"}},{"v":11.034525,"d":"11.03"},{"v":11.034525,"d":"11.03"},{"v":11.034525,"d":"11.03"},{"v":11.034525,"d":"11.03"},{"v":7.609100000000001,"d":"7.61"},{"v":7.609100000000001,"d":"7.61"},{"v":7.609100000000001,"d":"7.61"},{"v":7.609100000000001,"d":"7.61"},{"v":7.581566666666667,"d":"7.58"},{"v":7.581566666666667,"d":"7.58"}]
[null,"Отопление"]
[null,"Фактические расходы, гкал",299,299,299,299,299,299]
[null,"Отопительный период",8,8,8,8,8,8]
[null,"Количество Гкал в месяц",{"$f":"C90/C91","v":{"v":37.375,"d":"37.38"}},{"$f":"D90/D91","v":{"v":37.375,"d":"37.38"}},{"v":37.375,"d":"37.38"},{"v":37.375,"d":"37.38"},{"v":37.375,"d":"37.38"},{"v":37.375,"d":"37.38"}]
[null,"Площадь здания",1460.3,1717.3,1670.1,1983.9,3598,2001.4]
[null,"Площадь для занятий",60,60,60,60,60,60]
[null,"количество дней",30,30,30,30,30,30]
[null,"Количество работы",24,24,24,24,24,24]
[null,"Расходы на 1 час",1,1,1,1,1,1]
[null,"Количество Гкал в месяц",{"$f":"C92/C93*C94/C95/C96/C97","v":{"v":2.132838001323929E-3,"d":"0.0021"}},{"$f":"D92/D93*D94/D95/D96/D97","v":{"v":1.813651274287156E-3,"d":"0.0018"}},{"v":1.864908288924815E-3,"d":"0.0019"},{"v":1.5699295999462338E-3,"d":"0.0016"},{"v":8.6564294978691862E-4,"d":"0.0009"},{"v":1.5562023250391393E-3,"d":"0.0016"}]
[null,"Тариф",1808.56,1808.56,1808.56,1808.56,1808.56,1808.56]
[null,"Всего по отоплению",{"$f":"C98*C99","v":{"v":3.857365495674405,"d":"3.86"}},{"$f":"D98*D99","v":{"v":3.2800971486247787,"d":"3.28"}},{"v":3.3727985350178633,"d":"3.37"},{"v":2.8393118772787607,"d":"2.84"},{"v":1.5655672132666294,"d":"1.57"},{"v":2.8144852769727855,"d":"2.81"}]
[]
[null,"Газ на отопление"]
[null,"Фактические расходы, 10000куб.м.",{"$nulls":6},34.934,40.303,32.272,45.187,30.391,15.631]
[null,"Отопительный период",{"$nulls":6},8,8,8,8,8,8]
[null,"Количество куб.м. в месяц",{"$nulls":6},{"$f":"I103/I104","v":{"v":4.36675,"d":"4.37"}},{"$f":"J103/J104","v":{"v":5.037875,"d":"5.04"}},{"v":4.034,"d":"4.03"},{"v":5.648375,"d":"5.65"},{"v":3.798875,"d":"3.80"},{"v":1.953875,"d":"1.95"}]
[null,"Площадь здания",{"$nulls":6},1085.1,1151.1,1670.9,2585.8,1053.9,1053.9]
[null,"Площадь для занятий",{"$nulls":6},60,60,60,60,60,60]
[null,"количество дней",{"$nulls":6},30,30,30,30,30,30]
[null,"Количество работы, час",{"$nulls":6},24,24,24,24,24,24]
[null,"Расходы на 1 час",{"$nulls":6},1,1,1,1,1,1]
[null,"Количество куб.м. в месяц",{"$nulls":6},{"$f":"I105/I106*I107/I108/I109/I110","v":{"v":3.3535695634810924E-4,"d":"0.0003"}},{"$f":"J105/J106*J107/J108/J109/J110","v":{"v":3.6471454840297687E-4,"d":"0.0004"}},{"v":2.0118897999082331E-4,"d":"0.0002"},{"v":1.8203183411967926E-4,"d":"0.0002"},{"v":0.000300382310149603,"d":"0.0003"},{"v":0.000154495603630958,"d":"0.0002"}]
[null,"Тариф",{"$nulls":6},6437.18,6437.18,6437.18,6437.18,6437.18,6437.18]
[null,"Всего по отоплению (газ)",{"$nulls":6},{"$f":"I111*I112","v":{"v":2.158753092264922,"d":"2.16"}},{"$f":"J111*J112","v":{"v":2.347733196688675,"d":"2.35"}},{"v":1.295089678217328,"d":"1.30"},{"v":1.1717716819585169,"d":"1.17"},{"v":1.9336149992488216,"d":"1.93"},{"v":0.9945160097811303,"d":"0.99"}]
[null,"Общие затраты на коммунальные услуги",{"$f":"C65+C88+C100","v":{"v":19.206251718401507,"d":"19.21"}},{"$f":"D65+D88+D100","v":{"v":18.686826124107675,"d":"18.69"}},{"v":17.638757547082044,"d":"17.64"},{"v":16.34575100780368,"d":"16.35"},{"v":14.92401970882868,"d":"14.92"},{"v":15.98359091931347,"d":"15.98"},{"$f":"I65+I88+I113","v":{"v":16.128012944486066,"d":"16.13"}},{"v":15.614215966605812,"d":"15.61"},{"v":12.504078543161661,"d":"12.50"},{"v":12.68550248914245,"d":"12.69"},{"v":11.712703992741503,"d":"11.71"},{"v":10.773605003273811,"d":"10.77"}]
[null,"На 1 ребенка",{"$f":"C114/15","v":{"v":1.280416781226767,"d":"1.28"}},{"v":1.245788408273845,"d":"1.25"},{"v":1.1759171698054696,"d":"1.18"},{"v":1.0897167338535787,"d":"1.09"},{"v":0.9949346472552454,"d":"0.99"},{"v":1.0655727279542313,"d":"1.07"},{"$f":"I114/15","v":{"v":1.0752008629657377,"d":"1.08"}},{"$f":"J114/15","v":{"v":1.040947731107054,"d":"1.04"}},{"v":0.8336052362107774,"d":"0.83"},{"v":0.84570016594283,"d":"0.85"},{"v":0.7808469328494335,"d":"0.78"},{"v":0.7182403335515875,"d":"0.72"}]
[null,"Оплата труда уборщика служ. помещений"]
[null,"Оклад",11163,11163,11163,11163,11163,11163,11163,11163,11163,11163,11163,11163]
[null,"Начисления на оплату труда",{"$f":"C117*30.2%","v":3371.226},{"$f":"D117*30.2%","v":{"v":3371.226,"d":"3371.23"}},{"v":3371.226,"d":"3371.23"},{"v":3371.226,"d":"3371.23"},{"v":3371.226,"d":"3371.23"},{"v":3371.226,"d":"3371.23"},{"v":3371.226,"d":"3371.23"},{"v":3371.226,"d":"3371.23"},{"v":3371.226,"d":"3371.23"},{"v":3371.226,"d":"3371.23"},{"v":3371.226,"d":"3371.23"},{"v":3371.226,"d":"3371.23"}]
[null,"Всего",{"$f":"C117+C118","v":{"v":14534.226,"d":"14534.23"}},{"$f":"D117+D118","v":14534.226},14534.226,14534.226,14534.226,14534.226,14534.226,14534.226,14534.226,14534.226,14534.226,14534.226]
[null,"Нагрузка персонала, час",40,40,40,40,40,40,40,40,40,40,40,40]
[null,"Количество недель в месяце",4,4,4,4,4,4,4,4,4,4,4,4]
[null,"Количество детей в группе",15,15,15,15,15,15,15,15,15,15,15,15]
[null,"Всего по оплате труда тех. Песонала",{"$f":"C119/C120/C121/C122","v":{"v":6.0559275,"d":"6.06"}},{"$f":"D119/D120/D121/D122","v":{"v":6.0559275,"d":"6.06"}},{"v":6.0559275,"d":"6.06"},{"v":6.0559275,"d":"6.06"},{"v":6.0559275,"d":"6.06"},{"v":6.0559275,"d":"6.06"},{"v":6.0559275,"d":"6.06"},{"v":6.0559275,"d":"6.06"},{"v":6.0559275,"d":"6.06"},{"v":6.0559275,"d":"6.06"},{"v":6.0559275,"d":"6.06"},{"v":6.0559275,"d":"6.06"}]
[]
[null,"Материальные затраты"]
[null,"Канцелярские товары (для веденя документации) на 1 ребенка",1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3]
[null,"Стоимость",1404,1404,1404,1404,1404,1404,1404,1404,1404,1404,1404,1404]
[null,"Срок полезного использованя",8,8,8,8,8,8,8,8,8,8,8,8]
[null,"Количество детей",15,15,15,15,15,15,15,15,15,15,15,15]
[null,"Количество учебных месяцев",9,9,9,9,9,9,9,9,9,9,9,9]
[null,"Расходы в месяц",{"$f":"C127/C128","v":{"v":175.5,"d":"175.50"}},{"$f":"D127/D128","v":{"v":175.5,"d":"175.50"}},{"v":175.5,"d":"175.50"},{"v":175.5,"d":"175.50"},{"v":175.5,"d":"175.50"},{"v":175.5,"d":"175.50"},{"v":175.5,"d":"175.50"},{"v":175.5,"d":"175.50"},{"v":175.5,"d":"175.50"},{"v":175.5,"d":"175.50"},{"v":175.5,"d":"175.50"},{"v":175.5,"d":"175.50"}]
[null,"Затраты на 1 ребенка за одно занятие",{"$f":"C131/15/4","v":{"v":2.925,"d":"2.93"}},{"$f":"D131/15/4","v":{"v":2.925,"d":"2.93"}},{"v":2.925,"d":"2.93"},{"v":2.925,"d":"2.93"},{"v":2.925,"d":"2.93"},{"v":2.925,"d":"2.93"},{"v":2.925,"d":"2.93"},{"v":2.925,"d":"2.93"},{"v":2.925,"d":"2.93"},{"v":2.925,"d":"2.93"},{"v":2.925,"d":"2.93"},{"v":2.925,"d":"2.93"}]
[null,"Моющие средства для уборки помещенй на 1 ребенка",1.04,1.04,1.04,1.04,1.04,1.04,1.04,1.04,1.04,1.04,1.04,1.04]
[null,"Стоимость",1123.2,1123.2,1123.2,1123.2,1123.2,1123.2,1123.2,1123.2,1123.2,1123.2,1123.2,1123.2]
[null,"Срок полезного использованя",8,8,8,8,8,8,8,8,8,8,8,8]
[null,"Количество детей",15,15,15,15,15,15,15,15,15,15,15,15]
[null,"Количество учебных месяцев",9,9,9,9,9,9,9,9,9,9,9,9]
[null,"Расходы в месяц",{"$f":"C134/C135","v":140.4},{"$f":"D134/D135","v":140.4},140.4,140.4,140.4,140.4,140.4,140.4,140.4,140.4,140.4,140.4]
[null,"Затраты на 1 ребенка за одно занятие",{"$f":"C138/15/4","v":2.3400000000000003},{"$f":"D138/15/4","v":2.3400000000000003},2.3400000000000003,2.3400000000000003,2.3400000000000003,2.3400000000000003,2.3400000000000003,2.3400000000000003,2.3400000000000003,2.3400000000000003,2.3400000000000003,2.3400000000000003]
[null,"Итого по материальным затратам",{"$f":"C132+C139","v":{"v":5.265000000000001,"d":"5.27"}},{"$f":"D132+D139","v":{"v":5.265000000000001,"d":"5.27"}},{"v":5.265000000000001,"d":"5.27"},{"v":5.265000000000001,"d":"5.27"},{"v":5.265000000000001,"d":"5.27"},{"v":5.265000000000001,"d":"5.27"},{"v":5.265000000000001,"d":"5.27"},{"v":5.265000000000001,"d":"5.27"},{"v":5.265000000000001,"d":"5.27"},{"v":5.265000000000001,"d":"5.27"},{"v":5.265000000000001,"d":"5.27"},{"v":5.265000000000001,"d":"5.27"}]
[]
[null,"Расчет стоимости одного занятия на 1 человека"]
[null,"Расчет цены на оказание платной услуги"]
[null,"Затраты на оплату труда основного персонала",326.85,326.85,326.85,326.85,326.85,326.85,326.85,326.85,326.85,326.85,326.85,326.85]
[null,"Затраты материальных запасов",241.84,241.84,241.84,241.84,241.84,241.84,241.84,241.84,241.84,241.84,241.84,241.84]
[null,"Сумма начисленной амортизации оборудования, используемого при оказании платной услуги",239.42,239.42,239.42,239.42,239.42,239.42,239.42,239.42,239.42,239.42,239.42,239.42]
[null,"Накладные затраты, относмые на платные услуги",{"$f":"C55*15","v":{"v":189,"d":"189.00"}},{"$f":"D55*15","v":188.55},{"v":187.5,"d":"187.50"},186.15,{"v":184.8,"d":"184.80"},{"v":185.85000000000002,"d":"185.85"},{"v":186,"d":"186.00"},{"v":185.39999999999998,"d":"185.40"},182.25,182.55,{"v":181.5,"d":"181.50"},{"v":180.6,"d":"180.60"}]
[null,"Итого затрат",{"$f":"C144+C145+C146+C147","v":997.11},{"$f":"D144+D145+D146+D147","v":996.6600000000001},995.61,994.26,992.9100000000001,993.96,994.11,993.51,990.36,990.6600000000001,989.61,988.71]
[null,"Цена на 1 платную услугу ",{"$f":"C148/15","v":{"v":66.474,"d":"66.47"}},{"$f":"D148/15","v":{"v":66.444,"d":"66.44"}},{"v":66.374,"d":"66.37"},{"v":66.284,"d":"66.28"},{"v":66.194,"d":"66.19"},{"v":66.264,"d":"66.26"},{"v":66.274,"d":"66.27"},{"v":66.234,"d":"66.23"},{"v":66.024,"d":"66.02"},{"v":66.04400000000001,"d":"66.04"},{"v":65.974,"d":"65.97"},{"v":65.914,"d":"65.91"}]
[null,"Цена в месяц на 1 ребенка на 4 занятия",{"$f":"C149*4","v":{"v":265.896,"d":"266"}},{"$f":"D149*4","v":{"v":265.776,"d":"266"}},{"v":265.496,"d":"265"},{"v":265.136,"d":"265"},{"v":264.776,"d":"265"},{"v":265.056,"d":"265"},{"v":265.096,"d":"265"},{"v":264.936,"d":"265"},{"v":264.096,"d":"264"},{"v":264.17600000000004,"d":"264"},{"v":263.896,"d":"264"},{"v":263.656,"d":"264"}]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}